SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetTeacherInfoByLoginId]
    (
      @fdTeacLoginID VARCHAR(50)
    )
AS 
    SELECT  fdTeacLoginID,
            fdTeacPwd,
            fdTeacName,
            fdTeacCollID,
            fdTeacLoginAt,
            fdTeacLoginIp,
            fdTeacCreateAt,
            fdTeacLevel
    FROM    dbo.FS_Teacher
    WHERE   fdTeacLoginID = @fdTeacLoginID
GO
